CREATE EXTERNAL TABLE bidefault.dm_tab_cn_center_scan_lack_total_dt
(
    waybill_no                                              string COMMENT '运单号',
    next_station_network_code                               string COMMENT 'B路段目的站点',
    third_code                                              string COMMENT '三段码',
    ordersource_code                                        string COMMENT '多平台订单来源编码',
    ordersource_name                                        string COMMENT '多平台订单来源编码',
    send_station_loading_send_later_shipment_no             string COMMENT 'A路段始发站点任务号',
    next_station_unloading_arrival_early_shipment_no        string COMMENT 'B路段目的站点最早卸车到件扫描对应任务号',
    next_station_send_packagecode                           string COMMENT 'B路段目的站点发件扫描包号',
    next_station_arrival_packagecode                        string COMMENT 'B路段目的站点到件扫描包号',
    next_station_arrival_scan_user_code                     string COMMENT 'B路段目的站点到件扫描员CODE',
    next_station_arrival_scan_user                          string COMMENT 'B路段目的站点到件扫描员',
    next_station_send_scan_user                             string COMMENT 'B路段目的站点发件扫描员CODE',
    next_station_send_scan_user_code                        string COMMENT 'B路段目的站点发件扫描员',
    send_station_network_code                               string COMMENT 'A路段始发站点',
    send_station_network_type                               string COMMENT 'A路段始发站点类型',
    next_station_network_type                               string COMMENT 'B路段目的站点类型',
    send_station_send_next_network_code                     string COMMENT 'A路段始发站点发件扫描下一站点',
    send_station_send_next_network_type                     string COMMENT 'A路段始发站点发件扫描下一站点类型',
    send_station_send_later_time                            string COMMENT 'A路段始发中心/网点最晚发件时间',
    next_station_arrival_early_time                         string COMMENT 'B路段目的站点最早到件时间',
    next_station_send_later_time                            string COMMENT 'B路段目的站点最晚发件时间',
    sign_later_scantime                                     string COMMENT '最后一次签收时间',
    outstore_later_scantime                                 string COMMENT '最后一次出库时间',
    date_time                                               string COMMENT '日期',
    next_next_station_network_code                          string COMMENT 'B站点下一站',
    have_arr_no_send_flag                                   int COMMENT '1代表有到未发',
    have_send_no_arr_flag                                   int COMMENT '1代表有到未发',
    no_arr_no_send_flag                                     int COMMENT '1代表未到未发',
    have_arr_have_send_flag                                 int COMMENT '1代表有到有发',
    before_30_input                                         int COMMENT '1代表超过30天',
    input_time                                              string COMMENT '录入时间',
    other_scan_user_code                                    string COMMENT '到解车扫描雇员code',
    other_scan_user                                         string COMMENT '到解车扫描雇员name',
    unload_scan_time                                        string COMMENT '到解车扫描时间',
    next_send_station_unloading_arrival_early_shipment_name string COMMENT '本站卸车任务号',
    send_station_loading_send_later_shipment_name           string COMMENT '上一站装车任务号'
)
    COMMENT '中心漏扫明细base(重)'
    PARTITIONED BY (
        dt string COMMENT '订单录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/bidefault.db/external/dm_tab_cn_center_scan_lack_total_dt'
;